SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetRecruitInSchool]
	
	
	
	
AS
	/* SET NOCOUNT ON */
	
	SELECT  TOP 5 id,topic, update_time,start_time FROM dbo.JOL_Recruitment 
	WHERE type='校内专场' AND state=1
	 ORDER BY start_time DESC, update_time desc
	RETURN


GO
